﻿namespace Core
{
    internal static class ReportSettings
    {
        // Rows
        public const int HeaderRow = 1;
        public const int FirstContentRow = 2;
        public const int CompletedRow = 3;
        public const int RemainingRow = 10;
        public const int CompeltedInResolvedTasksRow = 17;
        public const int OriginalCoveredInResolvedTasksRow = 24;

        // Columns
        public const int IdColumn = 1;
        public const int RevColumn = 2;
        public const int NamesColumn = 1;
        public const int WorkItemTypeColumn = 3;
        public const int TitleColumn = 4;
        public const int AssignedToColumn = 5;
        public const int StateColumn = 6;
        public const int OriginalEstimateColumn = 7;
        public const int CompletedWorkColumn = 8;
        public const int RemainingWorkColumn = 9;
        public const int StackRankColumn = 10;
        public const int WasChangedByColumn = 11;
        public const int WasChangedDateColumn = 12;
        public const int CompletedWorkChangedColumn = 13;
        public const int RemainingWorkChangedColumn = 14;
        public const int ChangesetsColumn = 15;
        public const int DeltaColumn = 16;
        public const int HistoryColumn = 17;

        // FieldNames
        public const string OriginalEstimateName = "Microsoft.VSTS.Scheduling.OriginalEstimate";
        public const string RemainingWorkName = "Microsoft.VSTS.Scheduling.RemainingWork";
        public const string CompletedWorkName = "Microsoft.VSTS.Scheduling.CompletedWork";
        public const string StackRankName = "Microsoft.VSTS.Common.StackRank";

        // WorkSheets
        public const string DynamicsWorksheet = "Dynamics per day";
        public const string ResolvedWorksheet = "Resolved";
        public const string ReviewLogWorksheet = "Review log";

    }
}